select * from inventario

lx_cade e
sp_help

select * from V_ESTOQUE_PA_AJUSTE order by EMISSAO
update ESTOQUE_PROD_CONTAGEM set EMISSAO='20060101' where  CODIGO_INVENTARIO='00000001'
select * from inventario where   ULTIMO_AJUSTE < '20030102'

update ESTOQUE_PROD_CONTAGEM set FILIAL='PS PAULISTA' where NOME_CONTAGEM='jui'

delete from clientes_varejo where CODIGO_CLIENTE='0'
delete from loja_venda where CODIGO_CLIENTE='0'
select * from loja_venda where CODIGO_CLIENTE='0' and DATA_VENDA < '20030101'


select * from filiais

select * from loja_VENDA WHERE DATA_venda < '20030102'


delete from loja_VENDA WHERE TICKET='26175252'

select * from loja_VENDA WHERE TICKET='26175252'


select * from loja_venda where codigo_filial='02'

lx_cade 